﻿--****************  Ülkeler
SET IDENTITY_INSERT ESL.COUNTRY ON
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (1,'Türkiye');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (2,'KKTC');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (3,'Abd Virjin Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (4,'Afganistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (5,'Almanya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (6,'Amerika Birleşik Devletleri');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (7,'Amerikan Okyanusyası');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (8,'Andorra');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (9,'Angola');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (10,'Anguılla');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (11,'Antıgua Ve Bermuda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (12,'Arjantin');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (13,'Arnavutluk');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (14,'Aruba');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (15,'Avustralya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (16,'Avustralya Okyanusu');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (17,'Avusturya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (18,'Azerbeycan-Nahçıvan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (19,'Bahama');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (20,'Bahreyn');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (21,'Bangladeş');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (22,'Barbados');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (23,'Batı Samao');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (24,'Belçika');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (25,'Belize');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (26,'Benin');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (27,'Bermuda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (28,'Beyaz Rusya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (29,'Bhutan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (30,'Birleşik Arap Emirlikleri');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (31,'Birleşik Krallık');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (32,'Bismark Archipelago');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (33,'Bolivya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (34,'Bosna-Hersek');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (35,'Bostvana');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (36,'Brezilya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (37,'Brunei');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (38,'Bulgaristan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (39,'Burkina Faso');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (40,'Burma');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (41,'Burundi');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (42,'Cape Verde');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (43,'Cayman Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (44,'Cebeli Tarık');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (45,'Ceuta Ve Melilla');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (46,'Cezayir');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (47,'Cibuti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (48,'Cook Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (49,'Çad');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (50,'Çeçen Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (51,'Çek Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (52,'Çin Halk Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (53,'Dağıstan Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (54,'Danimarka');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (55,'Dominik Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (56,'Dominika');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (57,'Dubai');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (58,'Ekvator');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (59,'Ekvator Ginesi');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (60,'El Salvador');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (61,'Endonezya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (62,'Ermenistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (63,'Estonya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (64,'Etiyopya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (65,'Falkland Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (66,'Faroe Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (67,'Fas');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (68,'Fiji');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (69,'Fildişi Sahili');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (70,'Filipinler');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (71,'Finlandiya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (72,'Fransa');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (73,'Fransız Guyanası');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (74,'Fransız Polinezyası');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (75,'Gabon');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (76,'Gambiya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (77,'Gana');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (78,'Gazze');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (79,'Gine');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (80,'Gine-Bissau');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (81,'Grenada');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (82,'Grönland');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (83,'Guadelup');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (84,'Guatemala');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (85,'Guyana');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (86,'Güney Afrika Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (87,'Güney Kore Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (88,'Güney Yemen');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (89,'Gürcistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (90,'Haiti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (91,'Hırvatistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (92,'Hindistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (93,'Hollanda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (94,'Hollanda Antilleri');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (95,'Honduras');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (96,'Hong Kong');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (97,'Irak');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (98,'İngiliz Hint Oky.Toprakları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (99,'İngiliz Virjin Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (100,'İran');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (101,'İrlanda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (102,'İspanya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (103,'İsrail');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (104,'İsveç');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (105,'İsviçre');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (106,'İtalya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (107,'İzlanda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (108,'Jamaika');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (109,'Japonya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (110,'Kamboçya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (111,'Kamerun');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (112,'Kanada');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (113,'Kanarya Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (114,'Katar');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (115,'Kazakistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (116,'Kenya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (117,'Kırgızistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (118,'Kiribati');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (119,'Kolombiya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (120,'Komoro Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (121,'Kongo');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (122,'Kosta Rika');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (123,'Kutup Bölgeleri');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (124,'Kuveyt');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (125,'Kuzey Kore Demokratik Halk Cum.');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (126,'Kuzey Yemen');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (127,'Küba');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (128,'Laos');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (129,'Lesotho');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (130,'Letonya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (131,'Liberya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (132,'Libya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (133,'Litvanya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (134,'Lübnan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (135,'Lüksemburg');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (136,'Macaristan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (137,'Madagaskar');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (138,'Makao');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (139,'Makedonya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (140,'Malavi');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (141,'Maldiv Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (142,'Malezya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (143,'Mali');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (144,'Malta');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (145,'Martinik');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (146,'Mauritius');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (147,'Mayotte');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (148,'Meksika');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (149,'Merkezi Afrika Cumhuriyeti');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (150,'Mısır');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (151,'Moğolistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (152,'Moldavya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (153,'Monaco');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (154,'Moritanya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (155,'Mozambik');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (156,'Namibya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (157,'Nauru');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (158,'Nepal');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (159,'Nijer');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (160,'Nijerya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (161,'Nikaragua');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (162,'Norveç');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (163,'Özbekistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (164,'Pakistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (165,'Panama');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (166,'Papua Yeni Gine');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (167,'Paraguay');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (168,'Peru');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (169,'Pitcairn');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (170,'Polonya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (171,'Portekiz');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (172,'Reunion');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (173,'Romanya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (174,'Ruanda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (175,'Rum Kesimi');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (176,'Rusya Federasyonu');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (177,'Sao Tome And Prıncıpe');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (178,'Senegal');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (179,'Seyşel Adaları Ve Bağlantıları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (180,'Sıerra Leone');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (181,'Sırbistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (182,'Singapur');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (183,'Slovakya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (184,'Slovenya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (185,'Solomon Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (186,'Somali');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (187,'Sri Lanka');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (188,'St. Christopher Ve Nevis');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (189,'St. Helena Ve Bağlantıları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (190,'St. Lucia');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (191,'St. Pierre Ve Miquelon');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (192,'St. Vincent');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (193,'Sudan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (194,'Surinam');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (195,'Suriye');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (196,'Suudi Arabistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (197,'Svaziland');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (198,'Şili');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (199,'Tacikistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (200,'Tanzanya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (201,'Tataristan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (202,'Tayland');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (203,'Tayvan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (204,'Togo');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (205,'Tonga');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (206,'Trinidad Ve Tobago');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (207,'Tunus');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (208,'Turks Ve Caicos Adası');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (209,'Tuvalu');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (210,'Türkmenistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (211,'Uganda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (212,'Ukrayna');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (213,'Umman');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (214,'Uruguay');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (215,'Ürdün');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (216,'Vanuatu');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (217,'Vatikan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (218,'Venezuella');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (219,'Vietnam');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (220,'Wallis Ve Futuna Adaları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (221,'Yakutistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (222,'Yeni Kalodenya Ve Bağlantıları');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (223,'Yeni Zelanda');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (224,'Yeni Zelanda Okyanusu');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (225,'Yugoslavya');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (226,'Yunanistan');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (227,'Zaire');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (228,'Zambia');
INSERT INTO ESL.COUNTRY (Id,Name) VALUES (229,'Zimbabve');
SET IDENTITY_INSERT ESL.COUNTRY OFF
--****************  Ülkeler

--****************  Ülke Diğer Dillerde
SET IDENTITY_INSERT ESL.COUNTRY_LANG ON
INSERT INTO ESL.COUNTRY_LANG (Id,CountryId,LanguageId,Name) VALUES (101,1,10502,'Turkey');
INSERT INTO ESL.COUNTRY_LANG (Id,CountryId,LanguageId,Name) VALUES (201,2,10502,'Cyprus');
SET IDENTITY_INSERT ESL.COUNTRY_LANG OFF
--****************  Ülke Diğer Dillerde